# Query Description # Type of request: Extract data from a table # Name of the selected table: sophiecc # Description of the table: Cross-correlation functions # Restrict with the SQL clause: (dec between -1 and 1) AND (sn26 > 250) # Description of each column # seq: ----------------- Sequence number # $link[objname]: ------ Designation of the object # date: ---------------- Observation date # $link[slen]: --------- Length of the series # mask: ---------------- Name of the mask # ccf_offline: --------- Offline CCF # $field[rv]: ---------- Radial velocity # fwhm: ---------------- FWHM of the correlation peak # span: ---------------- Bissector span # maxcpp: -------------- Maximum number of counts per pixel # contrast: ------------ Contrast of the CCF # lines: --------------- Number of lines used for the CCF # $link['view_head']: -- See the header of the cross-correlation file # $link['get_ccf']: ---- Download the cross-correlation function FITS file # $link['view_ccf']: --- View the cross-correlation function #-------------- ------- --------------- ---- -- --------------- ---------------- -------- ------- --------------- ------ --------------- ----------- --------- ---------- #seq $link[o date $lin ma c $field[rv] fwhm span maxcpp contra l $link['view $link['ge $link['vie # bjname] k[sl sk c st i _head'] t_ccf'] w_ccf'] # en] f n # _ e # o s # f # f # l # i # n # e #------ ------- --------------- ---- -- - ---------------- -------- ------- ------- ------ - ----------- --------- ---------- 308590 HD097585 2007-02-13 1 G2 0 -256.062 99.305 38129 0.46 4727 view_head get_ccf view_ccf 310790 HD097585 2007-02-15 1 G2 0 -242.277 80.562 67956 0.36 4726 view_head get_ccf view_ccf 375170 MOON 2007-05-25 1 G2 0 -25.946 7.716 133861 40.79 4666 view_head get_ccf view_ccf 2096150 HD022484 2017-01-29 2 G2 0 28.119 0.0005 8.717 0.023 27233 32.92 4680 view_head get_ccf view_ccf 2092500 HD022484 2017-01-21 1 G2 0 28.117 0.0004 8.721 0.023 36959 33.03 4680 view_head get_ccf view_ccf 967480 HD181907 2010-06-24 1 G2 0 -17.343 0.0003 8.678 0.039 18788 54.15 4732 view_head get_ccf view_ccf 966160 HD181907 2010-06-22 1 G2 0 -17.334 0.0003 8.693 0.037 24888 54.31 4736 view_head get_ccf view_ccf 968140 HD181907 2010-06-25 1 G2 0 -17.351 0.0003 8.692 0.041 22579 54.12 4732 view_head get_ccf view_ccf 966770 HD181907 2010-06-23 1 G2 0 -17.364 0.0003 8.703 0.038 16829 54.11 4734 view_head get_ccf view_ccf 966860 HD181907 2010-06-23 1 G2 0 -17.376 0.0003 8.697 0.036 19179 54.28 4732 view_head get_ccf view_ccf 968050 HD181907 2010-06-25 1 G2 0 -17.346 0.0004 8.719 0.036 13805 53.44 4732 view_head get_ccf view_ccf 969170 HD181907 2010-06-27 1 G2 0 -17.367 0.0004 8.706 0.041 14983 53.72 4730 view_head get_ccf view_ccf 965600 HD181907 2010-06-21 1 G2 0 -17.304 0.0003 8.698 0.034 17516 54.36 4736 view_head get_ccf view_ccf 968490 HD181907 2010-06-26 1 G2 0 -17.345 0.0003 8.683 0.038 17401 53.91 4731 view_head get_ccf view_ccf 968530 HD181907 2010-06-26 1 G2 0 -17.361 0.0003 8.683 0.037 17224 53.93 4730 view_head get_ccf view_ccf 968080 HD181907 2010-06-25 1 G2 0 -17.348 0.0003 8.693 0.037 21035 54.12 4732 view_head get_ccf view_ccf 966800 HD181907 2010-06-23 1 G2 0 -17.368 0.0004 8.694 0.037 16744 54.24 4733 view_head get_ccf view_ccf 966220 HD181907 2010-06-22 1 G2 0 -17.299 0.0004 8.697 0.035 16472 54.07 4736 view_head get_ccf view_ccf 967450 HD181907 2010-06-24 1 G2 0 -17.355 0.0003 8.673 0.037 20911 54.28 4732 view_head get_ccf view_ccf 969200 HD181907 2010-06-27 1 G2 0 -17.356 0.0004 8.698 0.040 15692 53.86 4730 view_head get_ccf view_ccf 968590 HD181907 2010-06-26 1 G2 0 -17.367 0.0004 8.678 0.039 16545 53.98 4730 view_head get_ccf view_ccf 392000 HD181555 2007-06-23 2 G2 0 -39.761 73.957 16177 0.39 4729 view_head get_ccf view_ccf 1886601 HD022484 2015-11-16 1 G2 0 28.122 0.0005 8.808 0.023 21688 31.86 4716 view_head get_ccf view_ccf 1886601 HD022484 2015-11-16 1 G2 0 28.122 0.0005 8.808 0.023 21688 31.86 4716 view_head get_ccf view_ccf 1886591 HD022484 2015-11-16 1 G2 0 28.122 0.0005 8.828 0.023 27992 31.77 4716 view_head get_ccf view_ccf 1886591 HD022484 2015-11-16 1 G2 0 28.122 0.0005 8.828 0.023 27992 31.77 4716 view_head get_ccf view_ccf 966740 HD181907 2010-06-23 1 G2 0 -17.342 0.0003 8.768 0.036 15694 53.13 4734 view_head get_ccf view_ccf 387510 HD181555 2007-06-16 2 G2 0 -235.940 423.422 14487 2.53 4734 view_head get_ccf view_ccf 1881800 HD022484 2015-10-16 2 G2 0 28.112 0.0005 8.871 0.021 20109 31.03 4737 view_head get_ccf view_ccf 1881800 HD022484 2015-10-16 2 G2 0 28.112 0.0005 8.871 0.021 20109 31.03 4737 view_head get_ccf view_ccf 2096110 HD022484 2017-01-29 2 G2 0 28.118 0.0005 8.739 0.025 24513 32.67 4680 view_head get_ccf view_ccf 2096140 HD022484 2017-01-29 2 G2 0 28.117 0.0005 8.714 0.025 28424 32.95 4680 view_head get_ccf view_ccf 2012530 HD022484 2016-08-11 1 G2 0 28.122 0.0006 8.758 0.024 19786 32.54 4761 view_head get_ccf view_ccf 966250 HD181907 2010-06-22 1 G2 0 -17.306 0.0003 8.686 0.036 17942 54.23 4735 view_head get_ccf view_ccf 1700961 HD022484 2014-09-26 1 G2 0 28.121 0.0004 8.832 0.025 31101 31.69 4749 view_head get_ccf view_ccf 1867720 HD022484 2015-09-17 2 G2 0 28.126 0.0006 8.797 0.027 18174 31.94 4755 view_head get_ccf view_ccf 1867720 HD022484 2015-09-17 2 G2 0 28.126 0.0006 8.797 0.027 18174 31.94 4755 view_head get_ccf view_ccf 1869140 HD022484 2015-09-20 2 G2 0 28.111 0.0006 8.863 0.025 15509 31.53 4753 view_head get_ccf view_ccf 1869140 HD022484 2015-09-20 2 G2 0 28.111 0.0006 8.863 0.025 15509 31.53 4753 view_head get_ccf view_ccf 1869150 HD022484 2015-09-20 2 G2 0 28.114 0.0006 8.856 0.026 17338 31.63 4753 view_head get_ccf view_ccf 1869150 HD022484 2015-09-20 2 G2 0 28.114 0.0006 8.856 0.026 17338 31.63 4753 view_head get_ccf view_ccf 1869760 HD022484 2015-09-21 2 G2 0 28.117 0.0005 8.794 0.023 22107 31.95 4753 view_head get_ccf view_ccf 1869760 HD022484 2015-09-21 2 G2 0 28.117 0.0005 8.794 0.023 22107 31.95 4753 view_head get_ccf view_ccf 1869770 HD022484 2015-09-21 2 G2 0 28.119 0.0006 8.779 0.024 19147 32.11 4753 view_head get_ccf view_ccf 1869770 HD022484 2015-09-21 2 G2 0 28.119 0.0006 8.779 0.024 19147 32.11 4753 view_head get_ccf view_ccf 1868680 HD022484 2015-09-19 1 G2 0 28.115 0.0006 8.794 0.026 16511 32.01 4754 view_head get_ccf view_ccf 1868680 HD022484 2015-09-19 1 G2 0 28.115 0.0006 8.794 0.026 16511 32.01 4754 view_head get_ccf view_ccf 1868690 HD022484 2015-09-19 1 G2 0 28.117 0.0006 8.793 0.025 16908 32.00 4754 view_head get_ccf view_ccf 1868690 HD022484 2015-09-19 1 G2 0 28.117 0.0006 8.793 0.025 16908 32.00 4754 view_head get_ccf view_ccf 1868230 HD022484 2015-09-18 1 G2 0 28.120 0.0006 8.773 0.026 20089 32.20 4755 view_head get_ccf view_ccf 1868230 HD022484 2015-09-18 1 G2 0 28.120 0.0006 8.773 0.026 20089 32.20 4755 view_head get_ccf view_ccf 2013890 HD022484 2016-08-14 2 G2 0 28.123 0.0005 8.759 0.027 33074 32.64 4762 view_head get_ccf view_ccf 2013900 HD022484 2016-08-14 2 G2 0 28.122 0.0004 8.757 0.027 35509 32.69 4762 view_head get_ccf view_ccf 968110 HD181907 2010-06-25 1 G2 0 -17.343 0.0003 8.695 0.036 20079 54.03 4732 view_head get_ccf view_ccf 2092510 HD022484 2017-01-21 1 G2 0 28.119 0.0004 8.738 0.024 43217 32.81 4680 view_head get_ccf view_ccf 1722401 HD022484 2014-11-06 1 G2 0 28.119 0.0006 8.776 0.028 19361 32.19 4726 view_head get_ccf view_ccf 1722390 HD022484 2014-11-06 1 G2 0 28.119 0.0006 8.775 0.029 17554 32.16 4726 view_head get_ccf view_ccf 1723271 HD022484 2014-11-07 2 G2 0 28.115 0.0006 8.792 0.029 19018 32.01 4725 view_head get_ccf view_ccf 1723261 HD022484 2014-11-07 2 G2 0 28.119 0.0006 8.793 0.024 19781 32.05 4725 view_head get_ccf view_ccf 1723200 HD022484 2014-11-07 2 G2 0 28.117 0.0005 8.766 0.025 24262 32.33 4725 view_head get_ccf view_ccf 1723190 HD022484 2014-11-07 2 G2 0 28.121 0.0005 8.772 0.023 25897 32.31 4725 view_head get_ccf view_ccf 1723081 HD022484 2014-11-07 2 G2 0 28.114 0.0006 8.787 0.022 17115 32.05 4725 view_head get_ccf view_ccf 1723091 HD022484 2014-11-07 2 G2 0 28.117 0.0006 8.790 0.025 19137 32.06 4725 view_head get_ccf view_ccf 1757760 HD022484 2015-01-13 2 G2 0 28.107 0.0005 8.839 0.024 25227 31.83 4684 view_head get_ccf view_ccf 1758220 HD022484 2015-01-14 2 G2 0 28.120 0.0006 8.823 0.026 16364 31.89 4683 view_head get_ccf view_ccf 1758210 HD022484 2015-01-14 2 G2 0 28.123 0.0005 8.817 0.024 25287 31.98 4683 view_head get_ccf view_ccf 1919720 HD022484 2016-01-29 2 G2 0 28.111 0.0006 8.871 0.020 16433 31.23 4679 view_head get_ccf view_ccf 1919720 HD022484 2016-01-29 2 G2 0 28.111 0.0006 8.871 0.020 16433 31.23 4679 view_head get_ccf view_ccf 1919710 HD022484 2016-01-29 2 G2 0 28.118 0.0006 8.876 0.021 17902 31.12 4679 view_head get_ccf view_ccf 1919710 HD022484 2016-01-29 2 G2 0 28.118 0.0006 8.876 0.021 17902 31.12 4679 view_head get_ccf view_ccf 1887460 HD022484 2015-11-18 2 G2 0 28.125 0.0005 8.797 0.024 23224 31.99 4716 view_head get_ccf view_ccf 1887460 HD022484 2015-11-18 2 G2 0 28.125 0.0005 8.797 0.024 23224 31.99 4716 view_head get_ccf view_ccf 1887450 HD022484 2015-11-18 2 G2 0 28.122 0.0006 8.787 0.023 20746 32.06 4716 view_head get_ccf view_ccf 1887450 HD022484 2015-11-18 2 G2 0 28.122 0.0006 8.787 0.023 20746 32.06 4716 view_head get_ccf view_ccf 1700951 HD022484 2014-09-26 1 G2 0 28.122 0.0004 8.839 0.023 30789 31.63 4749 view_head get_ccf view_ccf 1700351 HD022484 2014-09-25 1 G2 0 28.120 0.0006 8.786 0.023 18090 32.01 4751 view_head get_ccf view_ccf 1700361 HD022484 2014-09-25 1 G2 0 28.120 0.0005 8.797 0.022 21619 31.94 4751 view_head get_ccf view_ccf 1881790 HD022484 2015-10-16 2 G2 0 28.112 0.0005 8.834 0.024 23607 31.65 4737 view_head get_ccf view_ccf 1881790 HD022484 2015-10-16 2 G2 0 28.112 0.0005 8.834 0.024 23607 31.65 4737 view_head get_ccf view_ccf 1883070 HD022484 2015-10-20 2 G2 0 28.119 0.0006 8.847 0.018 14252 31.51 4736 view_head get_ccf view_ccf 1883070 HD022484 2015-10-20 2 G2 0 28.119 0.0006 8.847 0.018 14252 31.51 4736 view_head get_ccf view_ccf 1918550 HD022484 2016-01-25 1 G2 0 28.117 0.0005 8.841 0.020 23901 31.70 4680 view_head get_ccf view_ccf 1918550 HD022484 2016-01-25 1 G2 0 28.117 0.0005 8.841 0.020 23901 31.70 4680 view_head get_ccf view_ccf 2091130 HD022484 2017-01-19 1 G2 0 28.120 0.0006 8.717 0.025 22611 32.86 4680 view_head get_ccf view_ccf 1672670 HD187929 2013-10-06 1 G2 0 7.180 0.0013 28.002 -6.020 18407 25.14 4681 view_head get_ccf view_ccf 1673020 HD187929 2013-10-07 1 G2 0 -1.171 0.0017 30.022 -6.050 26145 17.66 4681 view_head get_ccf view_ccf #-- end of data table ---------------------------------------------------------- # 86 lines were successfully retrieved